Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
In introducing specific financial function, we first of all to learn about common financial function parameters: Future value (fv) - all payments in the wake of the value of investments or loans. During the few (nper) - for a total investment (or loan), that the investment (or loan) the total number of payment period. Payment (pmt) - for an investment or loan to pay the regular amount. Its value in the annuity during the period remained unchanged. Pmt usually include principal and interest, but does not include other fees and taxes. Present value (pv) - beginning of period in the investment value of the investment or loan. For example, the present value of the loan for the principal amount borrowed. Interest rate (rate) - the investment or loan the interest rate or discount rate. Type (type) - the payment period to pay the interval, such as at the beginning or end of the month, with 0 or 1, said. Count on the base type (basis) - the benchmark for the type of day count. Basis is 0 or omitted on behalf of US (NASD) 30/360, 1 representative of sjts/ sjts, for 2 representatives of sjts/ 360, 3 on behalf of sjts/ 365, 4 on behalf of the European 30/360. Next, we will illustrate the financial function of a variety of applications. In this article introduces the various types of typical financial functions, financial functions more please see the Schedule and related books. Described below if the function is not available, return an error value # NAME?, Please install and load the "Analysis Tools" add-in. Method of operation for: 1, in the "Tools" menu, click "add-in." 2, in the "Available Add-in" list, select the "Analysis Tools" box, then click "OK." |
